All About Oracle Database Fragmentation

نویسنده

Craig A. Shallahamer

چکیده

There are many types of Oracle database fragmentation. Some are harmful and some are not. An active Oracle database will naturally foster harmful database fragmentation unless the DBA takes proactive application design and space management steps. This paper addresses tablespace freespace, segment, data block, index leaf block, and row fragmentation. Each fragmentation type is described in detail along with how to detect the fragmentation, how to quantify its intensity, what its performance and administration affects are, and how to resolve only the harmful fragmentation. Various scripts are used throughout the paper and references are made to publicly available tools.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Intelligent Implementation Processor Design for Oracle Distributed Databases System

Despite the increasing need for modeling and implementing Distributed Databases (DDB), distributed database management systems are still quite far from helping the designer to directly implement its BDD. Indeed, the fundamental principle of implementation of a DDB is to make the database appear as a centralized database, providing series of transparencies, something that is not provided directl...

متن کامل

Distributed University Registration Database System Using Oracle 9i

In database and information systems, increasing attention has been focused lately on parallel and distributed database systems. The future of large database systems lies into the realm of distributed computing. The main reason for this is that distributed computing can be constructed at a low cost without the need for any specialized technology, using existing sequential computers and relativel...

متن کامل

Conducting a Security Audit of an Oracle Database

Conducting a Security Audit of an Oracle Database The focus of the paper is on auditing access controls to Oracle databases. What should the auditor evaluate and test to enable him to give an informed opinion about the security of an information system based on an Oracle database? A number of issues that the auditor should evaluate are discussed in the paper, with indications of how these issue...

متن کامل